<?php
include '../conn.php';

?>
<!DOCTYPE html>
<html lang="zh">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <!-- <meta name="description" content=""> -->
    <!-- <meta name="author" content=""> -->
    <!-- <link rel="icon" href="../../favicon.ico"> -->

    <title>用户管理</title>

    <!-- Bootstrap core CSS -->
    <link href="./css/bootstrap.min.css" rel="stylesheet">

    <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
    <!-- <link href="../../assets/css/ie10-viewport-bug-workaround.css" rel="stylesheet"> -->

    <!-- Custom styles for this template -->
    <link href="./css/navbar-fixed-top.css" rel="stylesheet">

    <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
    <!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
    <!-- <script src="../../assets/js/ie-emulation-modes-warning.js"></script> -->

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->

    <script src="../js/jquery.js"></script>
      <script src="../js/jquery-3.4.1.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
    <!-- <script src="../../assets/js/ie10-viewport-bug-workaround.js"></script> -->

  </head>

  <body>

    <!-- Fixed navbar -->
    <?php include 'header.php'?>

    <div class="container">

      <!-- Main component for a primary marketing message or call to action -->
      <div class="jumbotron">
        <h1>用户管理</h1>
        <p>这里是用户管理，你可以对用户进行增删改查的管理</p>
        <p>精彩购物，尽在商城！</p>
      </div>

                <table class="table table-striped">

        <a href="adduser.php" class="btn btn-success">增加用户</a>
        <thead>
          <tr>
            <th>id</th>
            <th>用户名</th>
            <th>密码</th>
            <th>手机</th>
            <th>性别</th>
            <th>邮件</th>
            <th>地址</th>
            <th>操作</th>
          </tr>
        </thead>
        <tbody>
      <?php
      $sql = "SELECT * FROM user";
      $result = $conn->query($sql);

      if ($result->num_rows > 0) {
        // 输出每行数据
        while($row = $result->fetch_assoc()) {
          ?>

    <tr>
      <td><?php echo $row["id"]; ?></td>
      <td><?php echo $row["uname"]; ?></td>
      <td><?php echo $row["pwd"]; ?></td>
      <td><?php echo $row["tel"]; ?></td>
      <td><?php echo $row["sex"]; ?></td>
      <td><?php echo $row["email"]; ?></td>
      <td><?php echo $row["address"]; ?></td>
      <td>
        <a href="edituser.php?uid=<?php echo $row['id']?>" class="btn btn-primary">编辑</a>
        <!-- 按钮触发模态框 -->
          <button  class="btn btn-danger" data-toggle="modal" onclick="deluser(<?php echo $row['id']?>);" data-target="#myModal">删除</button>
      </td>
    </tr>

          <?php

        }
      } else {
        echo "0 个结果";
      }
      $conn->close();
      ?>
    </tbody>
  </table>

        <!-- 模态框（Modal） -->
        <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        <h4 class="modal-title" id="myModalLabel">提示</h4>
                    </div>
                    <div class="modal-body">确认是否要删除？</div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
                        <button type="button" id="del" class="btn btn-danger" >删除</button>
                        <script type="text/javascript">

                            function deluser(uid) {
                                $.post("deluser.php",{
                                    uid:uid,
                                },function(data,status){
                                    sleep(300);
                                    // if (data == 1) {
                                    alert('删除成功！');
                                    // }
                                    //休眠3秒
                                    sleep(300);
                                    //跳转商品列表
                                    location.href="userlist.php";

                                });
                            }
                            function sleep(n) { //n表示的毫秒数
                                var start = new Date().getTime();
                                while (true) if (new Date().getTime() - start > n) break;
                            }
                        </script>
                    </div>
                </div><!-- /.modal-content -->
            </div><!-- /.modal -->

        </div> <!-- /container -->

  </body>

</html>
